C/C++ Users Group Library 1996 July/C-C++ Users Group Library July 1996.iso/listings/v_02_01/2n01056a

Text File | 1990-11-24 | 309b | 13 lines

SELECT DISTINCT Machine#
FROM MachineParts Work1
WHERE NOT EXISTS
     (SELECT * FROM PickList
      WHERE NOT EXISTS
           (SELECT * FROM MachineParts Work2
             WHERE ((Work1.Machine# = Work2.Machine#)
               AND (Work2.Part# = PickList.Part#))
            )
      );